Sybase

The following table lists the data types that the ODBC driver supports for Sybase:

Table B-5. Mapping Sybase Data Types to ODBC Data Types  

Sybase Data Type	ODBC Data Type
BIGINT	SQL_BIGINT
BINARY	SQL_BINARY
BIT	SQL_BIT
CHAR	SQL_CHAR1 SQL_WCHAR2
DATETIME	SQL_TIMESTAMP3 SQL_CHAR4
DECIMAL	SQL_DECIMAL
FLOAT	SQL_FLOAT
IMAGE	SQL_LONGVARBINARY
INT	SQL_INTEGER
MONEY	SQL_DECIMAL
NUMERIC	SQL_NUMERIC
REAL	SQL_REAL
SMALLDATETIME	SQL_TIMESTAMP3 SQL_CHAR4
SMALLINT	SQL_SMALLINT
SMALLMONEY	SQL_DECIMAL
SYSNAME	SQL_VARCHAR5 SQL_WVARCHAR2
TEXT	SQL_LONGVARCHAR1 SQL_WLONGVARCHAR2
TIMESTAMP	SQL_BINARY
TINYINT	SQL_TINYINT
UBIGINT	SQL_DECIMAL
UNICHAR	SQL_WCHAR6
UNIVARCHAR	SQL_WVARCHAR6
VARBINARY	SQL_VARBINARY
VARCHAR	SQL_VARCHAR1 SQL_WVARCHAR2

1Not present when DataSourceReportChar=False and ServiceCodePage=Database 2Only present when ServiceCodePage=Database 3Only present when DataSourceFetchTimestampAsString=False 4Only present when DataSourceFetchTimestampAsString=True 5Not present when ServiceCodePage=Database 6Only present when ServiceCodePage=Database and database character set is UTF-8